<!DOCTYPE html>
<html lang="zh-cn">
<head>
    <title>项目列表</title>
    <?php PrintPageHead(); ?>
    <link href="../resource/css/hermes.css" rel="stylesheet">
    <link href="../resource/js/calendar/calendar-blue.css" type="text/css" rel="stylesheet">
    <script src="../resource/js/calendar/calendar.js" type="text/javascript"></script>
    <script src="../resource/js/hermes.js"></script>
    <style type="text/css">
        .divleft{width: 17%; float: left; text-align:left; border-right: solid 1px #d5d5d5; margin-right: 2% }
        .divleft2{width: 12%; float: left; text-align:left; border-right: solid 1px #d5d5d5; margin-right: 2% }
        .divright{ width: 6%; float:right; text-align: right;}


    </style>
    <?php
    if (!array_key_exists("公众号ID",$_SESSION)) {
        header("Location:back.php");
    }
    $bm=new C后台管理员();
    $参数=array();
    $sql ="SELECT a.*,b.`name` ,(SELECT COUNT(*) FROM `语音课程报名` c WHERE c.`课程id` = a.id ) AS `数量` FROM `语音课程` a LEFT JOIN `用户` b ON (a.`讲课专家id` = b.id) WHERE a.`type`='语音' ORDER BY a.id DESC ";
    $r显示2 =$bm->f通过sql分页($sql,@$_GET['page'],$_GET);

    ?>
</head>
<body>


<div class="container-fluid">
    <?php include_once 'back_header.php'; ?>
    <div class="panel panel-primary">
        <div class="panel-heading text-center"><h3 class="panel-title">管理语音课程</h3></div>
        <div class="panel-body">
            <div class="panel-group"   id="accordion" role="tablist" aria-multiselectable="true">
                <div class="panel panel-default" >
                    <div class="panel-heading" style="background-color:#d5d5d5" >
                        <div class="row">
                            <div class="col-xs-4 text-justify" style="width:100%;">
                                <div class="divleft"><b  >标题</b></div>
                                <div class="divleft2" > <b >时间</b></div>
                                <div class="divleft2" > <b >讲课专家</b></div>
                                <div class="divleft2" > <b >状态</b></div>
                                <div class="divleft2" > <b >关注人数</b></div>
                                <div class="divleft" > <b >简介</b></div>
                                <div class="divright" > <b >操作</b></div>

                            </div>
                        </div>
                    </div>
                </div>
                <div class="panel panel-default">
                    <?php foreach($r显示2['result'] as $key => $value):?>
                        <div class="panel-heading"  style=" <?php if($key%2==0){echo "background-color:#DFF0D8;";}else{ echo "border-top: solid 2px #ffffff;";}?>">
                            <div class="row">
                                <div class="col-xs-4 text-justify" style="width:100%;">
                                    <div class="divleft"><b  ><?= $value['title']?></b></div>
                                    <div class="divleft2" > <b ><?= $value['开始时间']?> ~ <?= $value['结束时间']?></b></div>
                                    <div class="divleft2" > <b ><?= $value['name']?></b></div>
                                    <div class="divleft2" > <b ><?= $value['状态']?></b></div>
                                    <div class="divleft2" > <b ><?= $value['数量']?></b></div>
                                    <div class="divleft" > <b ><?= $value['简介']?></b></div>
                                    <div class="divright" >
                                        <b ><a href="../back.php?state=back8Focus_Show&id=<?=$value['id']?>&title=<?= $value['title']?>&num=<?= $value['数量']?>">查看</a></b>
                                        <b >
                                            <?php if($value['状态'] =='预备' && date("Y-m-d H:i:s",(strtotime($value['开始时间']) - 3600)) > date("Y-m-d H:i:s")) echo '<a href="back.php?state=back8Voice_Lessons&id='.$value['id'].'">| 编辑</a>';?>
                                        </b>
                                    </div>


                                </div>
                            </div>
                        </div>
                    <?php endforeach; ?>

                </div>
            </div>
        </div>

        <?php  echo $r显示2['show'];?>
    </div>

</div>

<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="../resource/js/jquery-1.11.1.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="../resource/js/bootstrap.min.js"></script>

</body>
</html>